This option allows you to repeat the Create New Table Definitions process for a single existing SQL table and its associated Reality file.
Regenerate table offers the same methods for creating the table definition as Option 1: Create New Table Definitions:
Notes:
The Regenerate Table process is similar to that for Create New Table Definitions.
On selecting option 5 from the main menu, you are prompted:
Define Filename to be Processed… Enter Filename :
Enter the name of the Reality file for which you wish to regenerate the
SQL table. If you enter ?,
a list of files is displayed, from which you can select. See
Using the SQLM Menu Options.
You are then prompted:
Enter name of Table to be Regenerated: Enter Tablename :
Enter the name of the SQL table you wish to regenerate. If you enter ?, a list of tables is displayed, from which you can select. See Using the SQLM Menu Options.
You are then prompted:
Do you wish to: A. Update existing Table (keeping untouched entries) B. Totally replace existing Table Enter selection (A/B/EXit):
A,
any user-created definitions that are not overwritten will be retained.B,
any user-created definitions that are not overwritten will be deleted.EX,
you will be returned to the main menu.Continue from step 3 of the Create New Table Definitions process.